Profiling Report

Dataset statistics

Number of variables	34
Number of observations	142588
Missing cells	781636
Missing cells (%)	16.1%
Duplicate rows	33
Duplicate rows (%)	< 0.1%
Total size in memory	37.0 MiB
Average record size in memory	272.0 B

Variable types

Numeric	7
Boolean	4
Categorical	12
DateTime	4
Text	6
Unsupported	1

Alerts

Dataset has 33 (< 0.1%) duplicate rows	Duplicates
is highly overall correlated with `business_name` and 1 other fields	High correlation
`business_name` is highly overall correlated with and 2 other fields	High correlation
`case_linked` is highly overall correlated with `business_name` and 1 other fields	High correlation
`case_type` is highly overall correlated with `case_linked`	High correlation
`customer_type` is highly overall correlated with	High correlation
`day_of_month` is highly overall correlated with `month_period`	High correlation
`month_period` is highly overall correlated with `day_of_month`	High correlation
`referred` is highly overall correlated with `business_name`	High correlation
`total_cxl_appointments_before_appointment` is highly overall correlated with `total_good_appointments_before_appointment`	High correlation
`total_good_appointments_before_appointment` is highly overall correlated with `total_cxl_appointments_before_appointment`	High correlation
`patient_status` is highly imbalanced (81.3%)	Imbalance
`patient_type` is highly imbalanced (62.1%)	Imbalance
`missed` is highly imbalanced (89.4%)	Imbalance
`title` is highly imbalanced (54.8%)	Imbalance
`sex` is highly imbalanced (63.6%)	Imbalance
`case_type` has 61949 (43.4%) missing values	Missing
`next_appointment_time` has 116141 (81.5%) missing values	Missing
`cancelled_at` has 119696 (83.9%) missing values	Missing
`billable_item` has 3942 (2.8%) missing values	Missing
`category` has 24476 (17.2%) missing values	Missing
`customer_type` has 103758 (72.8%) missing values	Missing
`title` has 58854 (41.3%) missing values	Missing
`state` has 71910 (50.4%) missing values	Missing
`date_of_birth` has 2578 (1.8%) missing values	Missing
`sex` has 49112 (34.4%) missing values	Missing
`post_code` has 51112 (35.8%) missing values	Missing
`city` has 49994 (35.1%) missing values	Missing
`occupation` has 68082 (47.7%) missing values	Missing
`post_code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`total_open_invoices_before_appointemnt` has 133150 (93.4%) zeros	Zeros
`total_good_appointments_before_appointment` has 15297 (10.7%) zeros	Zeros
`total_cxl_appointments_before_appointment` has 87748 (61.5%) zeros	Zeros
`notice` has 119702 (83.9%) zeros	Zeros

Reproduction

Analysis started	2024-06-09 11:06:47.030382
Analysis finished	2024-06-09 11:07:48.681626
Duration	1 minute and 1.65 second
Software version	ydata-profiling v4.8.3
Download configuration	config.json

Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.531125

Minimum	2
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	2
5-th percentile	12
Q1	12
median	13
Q3	16
95-th percentile	16
Maximum	16
Range	14
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.8397643
Coefficient of variation (CV)	0.13596536
Kurtosis	-1.4498233
Mean	13.531125
Median Absolute Deviation (MAD)	1
Skewness	0.45622436
Sum	1929376
Variance	3.3847326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
12	57664	40.4%
16	48654	34.1%
13	29681	20.8%
11	6410	4.5%
15	171	0.1%
2	8	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	8	< 0.1%
11	6410	4.5%
12	57664	40.4%
13	29681	20.8%
15	171	0.1%
16	48654	34.1%

Value	Count	Frequency (%)
16	48654	34.1%
15	171	0.1%
13	29681	20.8%
12	57664	40.4%
11	6410	4.5%
2	8	< 0.1%

case_linked
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.4 KiB

True	80639
False	61949

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	80639	56.6%
False	61949	43.4%

case_type
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	61949
Missing (%)	43.4%
Memory size	1.1 MiB

Unlimited	59368
Max Sessions	21167
Max Amount	104

Length

Max length	12
Median length	9
Mean length	9.7887623
Min length	9

Characters and Unicode

Total characters	789356
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Unlimited
2nd row	Unlimited
3rd row	Unlimited
4th row	Unlimited
5th row	Unlimited

Common Values

Value	Count	Frequency (%)
Unlimited	59368	41.6%
Max Sessions	21167	14.8%
Max Amount	104	0.1%
(Missing)	61949	43.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
unlimited	59368	58.3%
max	21271	20.9%
sessions	21167	20.8%
amount	104	0.1%

Most occurring characters

Value	Count	Frequency (%)
i	139903	17.7%
n	80639	10.2%
e	80535	10.2%
s	63501	8.0%
m	59472	7.5%
t	59472	7.5%
U	59368	7.5%
l	59368	7.5%
d	59368	7.5%
	21271	2.7%
Other values (7)	106459	13.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	789356	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	139903	17.7%
n	80639	10.2%
e	80535	10.2%
s	63501	8.0%
m	59472	7.5%
t	59472	7.5%
U	59368	7.5%
l	59368	7.5%
d	59368	7.5%
	21271	2.7%
Other values (7)	106459	13.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	789356	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	139903	17.7%
n	80639	10.2%
e	80535	10.2%
s	63501	8.0%
m	59472	7.5%
t	59472	7.5%
U	59368	7.5%
l	59368	7.5%
d	59368	7.5%
	21271	2.7%
Other values (7)	106459	13.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	789356	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	139903	17.7%
n	80639	10.2%
e	80535	10.2%
s	63501	8.0%
m	59472	7.5%
t	59472	7.5%
U	59368	7.5%
l	59368	7.5%
d	59368	7.5%
	21271	2.7%
Other values (7)	106459	13.5%

total_open_invoices_before_appointemnt
Real number (ℝ)

ZEROS

Distinct	37
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15844251

Minimum	0
Maximum	36
Zeros	133150
Zeros (%)	93.4%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	36
Range	36
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.89940366
Coefficient of variation (CV)	5.6765302
Kurtosis	236.06917
Mean	0.15844251
Median Absolute Deviation (MAD)	0
Skewness	12.036222
Sum	22592
Variance	0.80892695
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	133150	93.4%
1	4897	3.4%
2	1966	1.4%
3	933	0.7%
4	597	0.4%
5	267	0.2%
6	179	0.1%
7	159	0.1%
9	120	0.1%
8	92	0.1%
Other values (27)	228	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	133150	93.4%
1	4897	3.4%
2	1966	1.4%
3	933	0.7%
4	597	0.4%
5	267	0.2%
6	179	0.1%
7	159	0.1%
8	92	0.1%
9	120	0.1%

Value	Count	Frequency (%)
36	1	< 0.1%
35	1	< 0.1%
34	1	< 0.1%
33	1	< 0.1%
32	1	< 0.1%
31	1	< 0.1%
30	1	< 0.1%
29	1	< 0.1%
28	1	< 0.1%
27	2	< 0.1%

total_good_appointments_before_appointment
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	335
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.58918

Minimum	0
Maximum	334
Zeros	15297
Zeros (%)	10.7%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	10
95-th percentile	45
Maximum	334
Range	334
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	23.449078
Coefficient of variation (CV)	2.2144375
Kurtosis	44.197321
Mean	10.58918
Median Absolute Deviation (MAD)	2
Skewness	5.7101934
Sum	1509890
Variance	549.85924
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	32620	22.9%
0	15297	10.7%
2	13329	9.3%
3	10798	7.6%
4	8875	6.2%
5	7313	5.1%
6	5940	4.2%
7	4888	3.4%
8	4146	2.9%
9	3541	2.5%
Other values (325)	35841	25.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15297	10.7%
1	32620	22.9%
2	13329	9.3%
3	10798	7.6%
4	8875	6.2%
5	7313	5.1%
6	5940	4.2%
7	4888	3.4%
8	4146	2.9%
9	3541	2.5%

Value	Count	Frequency (%)
334	1	< 0.1%
333	1	< 0.1%
332	1	< 0.1%
331	1	< 0.1%
330	1	< 0.1%
329	1	< 0.1%
328	1	< 0.1%
327	1	< 0.1%
326	1	< 0.1%
325	1	< 0.1%

total_cxl_appointments_before_appointment
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	134
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6344924

Minimum	0
Maximum	145
Zeros	87748
Zeros (%)	61.5%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	13
Maximum	145
Range	145
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	8.6717357
Coefficient of variation (CV)	3.2916154
Kurtosis	76.642096
Mean	2.6344924
Median Absolute Deviation (MAD)	0
Skewness	7.4385572
Sum	375647
Variance	75.199
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	87748	61.5%
1	19022	13.3%
2	8624	6.0%
3	5195	3.6%
4	3739	2.6%
5	2731	1.9%
6	2069	1.5%
7	1472	1.0%
8	1220	0.9%
9	1155	0.8%
Other values (124)	9613	6.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	87748	61.5%
1	19022	13.3%
2	8624	6.0%
3	5195	3.6%
4	3739	2.6%
5	2731	1.9%
6	2069	1.5%
7	1472	1.0%
8	1220	0.9%
9	1155	0.8%

Value	Count	Frequency (%)
145	22	< 0.1%
144	12	< 0.1%
143	22	< 0.1%
142	1	< 0.1%
141	2	< 0.1%
140	3	< 0.1%
139	2	< 0.1%
138	3	< 0.1%
137	1	< 0.1%
136	3	< 0.1%

patient_status
Categorical

IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Not Yet Actioned	129550
Therapist Follow Up	7366
Has An Upcoming Booking	2191
Patient Stopped Treatment	1694
Admin Follow Up	850
Other values (5)	937

Length

Max length	25
Median length	16
Mean length	16.380516
Min length	14

Characters and Unicode

Total characters	2335665
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Yet Actioned
2nd row	Not Yet Actioned
3rd row	Not Yet Actioned
4th row	Not Yet Actioned
5th row	Not Yet Actioned

Common Values

Value	Count	Frequency (%)
Not Yet Actioned	129550	90.9%
Therapist Follow Up	7366	5.2%
Has An Upcoming Booking	2191	1.5%
Patient Stopped Treatment	1694	1.2%
Admin Follow Up	850	0.6%
Discharged By Therapist	352	0.2%
On Waiting List	322	0.2%
Staff & Family	126	0.1%
Contacted Too Many Times	81	0.1%
Do Not Contact	56	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
not	129606	30.1%
actioned	129550	30.1%
yet	129550	30.1%
follow	8216	1.9%
up	8216	1.9%
therapist	7718	1.8%
has	2191	0.5%
an	2191	0.5%
upcoming	2191	0.5%
booking	2191	0.5%
Other values (18)	8416	2.0%

Most occurring characters

Value	Count	Frequency (%)
t	405938	17.4%
	287448	12.3%
o	284210	12.2%
e	274108	11.7%
i	145719	6.2%
n	141223	6.0%
A	132591	5.7%
d	132527	5.7%
c	132230	5.7%
N	129606	5.5%
Other values (27)	270065	11.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2335665	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	405938	17.4%
	287448	12.3%
o	284210	12.2%
e	274108	11.7%
i	145719	6.2%
n	141223	6.0%
A	132591	5.7%
d	132527	5.7%
c	132230	5.7%
N	129606	5.5%
Other values (27)	270065	11.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2335665	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	405938	17.4%
	287448	12.3%
o	284210	12.2%
e	274108	11.7%
i	145719	6.2%
n	141223	6.0%
A	132591	5.7%
d	132527	5.7%
c	132230	5.7%
N	129606	5.5%
Other values (27)	270065	11.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2335665	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	405938	17.4%
	287448	12.3%
o	284210	12.2%
e	274108	11.7%
i	145719	6.2%
n	141223	6.0%
A	132591	5.7%
d	132527	5.7%
c	132230	5.7%
N	129606	5.5%
Other values (27)	270065	11.6%

patient_type
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Recurring	119797
new injury/issue	12173
New To Clinic	6249
new to therapist	3908
new to service	461

Length

Max length	16
Median length	9
Mean length	9.9809241
Min length	9

Characters and Unicode

Total characters	1423160
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	New To Clinic
2nd row	Recurring
3rd row	Recurring
4th row	Recurring
5th row	New To Clinic

Common Values

Value	Count	Frequency (%)
Recurring	119797	84.0%
new injury/issue	12173	8.5%
New To Clinic	6249	4.4%
new to therapist	3908	2.7%
new to service	461	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
recurring	119797	68.1%
new	22791	12.9%
injury/issue	12173	6.9%
to	10618	6.0%
clinic	6249	3.6%
therapist	3908	2.2%
service	461	0.3%

Most occurring characters

Value	Count	Frequency (%)
r	256136	18.0%
i	161010	11.3%
e	159591	11.2%
n	154761	10.9%
u	144143	10.1%
c	126507	8.9%
R	119797	8.4%
g	119797	8.4%
	33409	2.3%
s	28715	2.0%
Other values (14)	119294	8.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1423160	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	256136	18.0%
i	161010	11.3%
e	159591	11.2%
n	154761	10.9%
u	144143	10.1%
c	126507	8.9%
R	119797	8.4%
g	119797	8.4%
	33409	2.3%
s	28715	2.0%
Other values (14)	119294	8.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1423160	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	256136	18.0%
i	161010	11.3%
e	159591	11.2%
n	154761	10.9%
u	144143	10.1%
c	126507	8.9%
R	119797	8.4%
g	119797	8.4%
	33409	2.3%
s	28715	2.0%
Other values (14)	119294	8.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1423160	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	256136	18.0%
i	161010	11.3%
e	159591	11.2%
n	154761	10.9%
u	144143	10.1%
c	126507	8.9%
R	119797	8.4%
g	119797	8.4%
	33409	2.3%
s	28715	2.0%
Other values (14)	119294	8.4%

time_of_day
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Late Afternoon	68696
Late Morning	50404
Early Morning	14476
Evening	9012

Length

Max length	14
Median length	13
Mean length	12.749067
Min length	7

Characters and Unicode

Total characters	1817864
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Early Morning
2nd row	Late Afternoon
3rd row	Late Morning
4th row	Late Morning
5th row	Early Morning

Common Values

Value	Count	Frequency (%)
Late Afternoon	68696	48.2%
Late Morning	50404	35.3%
Early Morning	14476	10.2%
Evening	9012	6.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
late	119100	43.1%
afternoon	68696	24.9%
morning	64880	23.5%
early	14476	5.2%
evening	9012	3.3%

Most occurring characters

Value	Count	Frequency (%)
n	285176	15.7%
o	202272	11.1%
e	196808	10.8%
t	187796	10.3%
r	148052	8.1%
	133576	7.3%
a	133576	7.3%
L	119100	6.6%
i	73892	4.1%
g	73892	4.1%
Other values (7)	263724	14.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1817864	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	285176	15.7%
o	202272	11.1%
e	196808	10.8%
t	187796	10.3%
r	148052	8.1%
	133576	7.3%
a	133576	7.3%
L	119100	6.6%
i	73892	4.1%
g	73892	4.1%
Other values (7)	263724	14.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1817864	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	285176	15.7%
o	202272	11.1%
e	196808	10.8%
t	187796	10.3%
r	148052	8.1%
	133576	7.3%
a	133576	7.3%
L	119100	6.6%
i	73892	4.1%
g	73892	4.1%
Other values (7)	263724	14.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1817864	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	285176	15.7%
o	202272	11.1%
e	196808	10.8%
t	187796	10.3%
r	148052	8.1%
	133576	7.3%
a	133576	7.3%
L	119100	6.6%
i	73892	4.1%
g	73892	4.1%
Other values (7)	263724	14.5%

month_period
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Mid month	49458
End month	46869
Early month	46261

Length

Max length	11
Median length	9
Mean length	9.6488765
Min length	9

Characters and Unicode

Total characters	1375814
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mid month
2nd row	Mid month
3rd row	Mid month
4th row	Mid month
5th row	End month

Common Values

Value	Count	Frequency (%)
Mid month	49458	34.7%
End month	46869	32.9%
Early month	46261	32.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
month	142588	50.0%
mid	49458	17.3%
end	46869	16.4%
early	46261	16.2%

Most occurring characters

Value	Count	Frequency (%)
n	189457	13.8%
	142588	10.4%
m	142588	10.4%
o	142588	10.4%
t	142588	10.4%
h	142588	10.4%
d	96327	7.0%
E	93130	6.8%
M	49458	3.6%
i	49458	3.6%
Other values (4)	185044	13.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1375814	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	189457	13.8%
	142588	10.4%
m	142588	10.4%
o	142588	10.4%
t	142588	10.4%
h	142588	10.4%
d	96327	7.0%
E	93130	6.8%
M	49458	3.6%
i	49458	3.6%
Other values (4)	185044	13.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1375814	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	189457	13.8%
	142588	10.4%
m	142588	10.4%
o	142588	10.4%
t	142588	10.4%
h	142588	10.4%
d	96327	7.0%
E	93130	6.8%
M	49458	3.6%
i	49458	3.6%
Other values (4)	185044	13.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1375814	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	189457	13.8%
	142588	10.4%
m	142588	10.4%
o	142588	10.4%
t	142588	10.4%
h	142588	10.4%
d	96327	7.0%
E	93130	6.8%
M	49458	3.6%
i	49458	3.6%
Other values (4)	185044	13.4%

day_of_week
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	8
Missing (%)	< 0.1%
Memory size	1.1 MiB

Thursday	29586
Tuesday	27986
Wednesday	27877
Monday	24398
Friday	24219
Other values (2)	8514

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1283220
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Friday
2nd row	Thursday
3rd row	Thursday
4th row	Friday
5th row	Monday

Common Values

Value	Count	Frequency (%)
Thursday	29586	20.7%
Tuesday	27986	19.6%
Wednesday	27877	19.6%
Monday	24398	17.1%
Friday	24219	17.0%
Saturday	7958	5.6%
Sunday	556	0.4%
(Missing)	8	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
thursday	29586	20.8%
tuesday	27986	19.6%
wednesday	27877	19.6%
monday	24398	17.1%
friday	24219	17.0%
saturday	7958	5.6%
sunday	556	0.4%

Most occurring characters

Value	Count	Frequency (%)
	241035	18.8%
d	170457	13.3%
a	150538	11.7%
y	142580	11.1%
s	85449	6.7%
e	83740	6.5%
u	66086	5.2%
r	61763	4.8%
T	57572	4.5%
n	52831	4.1%
Other values (8)	171169	13.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1283220	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	241035	18.8%
d	170457	13.3%
a	150538	11.7%
y	142580	11.1%
s	85449	6.7%
e	83740	6.5%
u	66086	5.2%
r	61763	4.8%
T	57572	4.5%
n	52831	4.1%
Other values (8)	171169	13.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1283220	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	241035	18.8%
d	170457	13.3%
a	150538	11.7%
y	142580	11.1%
s	85449	6.7%
e	83740	6.5%
u	66086	5.2%
r	61763	4.8%
T	57572	4.5%
n	52831	4.1%
Other values (8)	171169	13.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1283220	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	241035	18.8%
d	170457	13.3%
a	150538	11.7%
y	142580	11.1%
s	85449	6.7%
e	83740	6.5%
u	66086	5.2%
r	61763	4.8%
T	57572	4.5%
n	52831	4.1%
Other values (8)	171169	13.3%

month_of_year
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	8
Missing (%)	< 0.1%
Memory size	1.1 MiB

May	15437
March	14400
February	13293
June	13225
April	12850
Other values (7)	73375

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1283220
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	August
3rd row	August
4th row	September
5th row	September

Common Values

Value	Count	Frequency (%)
May	15437	10.8%
March	14400	10.1%
February	13293	9.3%
June	13225	9.3%
April	12850	9.0%
November	12360	8.7%
January	12343	8.7%
December	10663	7.5%
July	9976	7.0%
October	9622	6.7%
Other values (2)	18411	12.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
may	15437	10.8%
march	14400	10.1%
february	13293	9.3%
june	13225	9.3%
april	12850	9.0%
november	12360	8.7%
january	12343	8.7%
december	10663	7.5%
july	9976	7.0%
october	9622	6.7%
Other values (2)	18411	12.9%

Most occurring characters

Value	Count	Frequency (%)
	426589	33.2%
e	119366	9.3%
r	107663	8.4%
u	67981	5.3%
a	67816	5.3%
b	54777	4.3%
y	51049	4.0%
J	35544	2.8%
c	34685	2.7%
m	31862	2.5%
Other values (17)	285888	22.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1283220	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	426589	33.2%
e	119366	9.3%
r	107663	8.4%
u	67981	5.3%
a	67816	5.3%
b	54777	4.3%
y	51049	4.0%
J	35544	2.8%
c	34685	2.7%
m	31862	2.5%
Other values (17)	285888	22.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1283220	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	426589	33.2%
e	119366	9.3%
r	107663	8.4%
u	67981	5.3%
a	67816	5.3%
b	54777	4.3%
y	51049	4.0%
J	35544	2.8%
c	34685	2.7%
m	31862	2.5%
Other values (17)	285888	22.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1283220	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	426589	33.2%
e	119366	9.3%
r	107663	8.4%
u	67981	5.3%
a	67816	5.3%
b	54777	4.3%
y	51049	4.0%
J	35544	2.8%
c	34685	2.7%
m	31862	2.5%
Other values (17)	285888	22.3%

day_of_month
Real number (ℝ)

HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	8
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	15.621911

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.6304372
Coefficient of variation (CV)	0.55245722
Kurtosis	-1.1425088
Mean	15.621911
Median Absolute Deviation (MAD)	7
Skewness	0.031020007
Sum	2227372
Variance	74.484447
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
15	5282	3.7%
20	5142	3.6%
13	5108	3.6%
22	5045	3.5%
8	5008	3.5%
16	4960	3.5%
14	4955	3.5%
9	4886	3.4%
19	4868	3.4%
11	4834	3.4%
Other values (21)	92492	64.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4287	3.0%
2	4307	3.0%
3	4529	3.2%
4	4740	3.3%
5	4682	3.3%
6	4820	3.4%
7	4634	3.2%
8	5008	3.5%
9	4886	3.4%
10	4368	3.1%

Value	Count	Frequency (%)
31	2597	1.8%
30	3998	2.8%
29	4335	3.0%
28	4434	3.1%
27	4715	3.3%
26	3792	2.7%
25	3844	2.7%
24	4466	3.1%
23	4811	3.4%
22	5045	3.5%

week_of_year
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	8
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	24.938708

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	12
median	23
Q3	38
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	14.939851
Coefficient of variation (CV)	0.59906273
Kurtosis	-1.1778436
Mean	24.938708
Median Absolute Deviation (MAD)	13
Skewness	0.20220916
Sum	3555761
Variance	223.19913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22	3688	2.6%
12	3505	2.5%
20	3477	2.4%
19	3431	2.4%
23	3419	2.4%
18	3366	2.4%
10	3365	2.4%
21	3359	2.4%
6	3287	2.3%
8	3257	2.3%
Other values (43)	108426	76.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1820	1.3%
2	3111	2.2%
3	3201	2.2%
4	2755	1.9%
5	3253	2.3%
6	3287	2.3%
7	3209	2.3%
8	3257	2.3%
9	3201	2.2%
10	3365	2.4%

Value	Count	Frequency (%)
53	69	< 0.1%
52	724	0.5%
51	3016	2.1%
50	3133	2.2%
49	2978	2.1%
48	2970	2.1%
47	3011	2.1%
46	3107	2.2%
45	2624	1.8%
44	2324	1.6%

appointment_status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Not Rebooked	116141
Rebooked	26447

Length

Max length	12
Median length	12
Mean length	11.258086
Min length	8

Characters and Unicode

Total characters	1605268
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Rebooked
2nd row	Not Rebooked
3rd row	Not Rebooked
4th row	Not Rebooked
5th row	Not Rebooked

Common Values

Value	Count	Frequency (%)
Not Rebooked	116141	81.5%
Rebooked	26447	18.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rebooked	142588	55.1%
not	116141	44.9%

Most occurring characters

Value	Count	Frequency (%)
o	401317	25.0%
e	285176	17.8%
R	142588	8.9%
b	142588	8.9%
k	142588	8.9%
d	142588	8.9%
N	116141	7.2%
t	116141	7.2%
	116141	7.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1605268	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	401317	25.0%
e	285176	17.8%
R	142588	8.9%
b	142588	8.9%
k	142588	8.9%
d	142588	8.9%
N	116141	7.2%
t	116141	7.2%
	116141	7.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1605268	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	401317	25.0%
e	285176	17.8%
R	142588	8.9%
b	142588	8.9%
k	142588	8.9%
d	142588	8.9%
N	116141	7.2%
t	116141	7.2%
	116141	7.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1605268	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	401317	25.0%
e	285176	17.8%
R	142588	8.9%
b	142588	8.9%
k	142588	8.9%
d	142588	8.9%
N	116141	7.2%
t	116141	7.2%
	116141	7.2%

next_appointment_time
Date

MISSING

Distinct	13826
Distinct (%)	52.3%
Missing	116141
Missing (%)	81.5%
Memory size	1.1 MiB

Minimum	2020-10-26 10:00:00
Maximum	2026-01-01 09:30:00

Histogram

Histogram with fixed size bins (bins=50)

notice
Real number (ℝ)

ZEROS

Distinct	14995
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-841.51892

Minimum	-65869.14
Maximum	17186.2
Zeros	119702
Zeros (%)	83.9%
Negative	7672
Negative (%)	5.4%
Memory size	1.1 MiB

Quantile statistics

Minimum	-65869.14
5-th percentile	-1042.24
Q1	0
median	0
Q3	0
95-th percentile	27.1265
Maximum	17186.2
Range	83055.34
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4682.9759
Coefficient of variation (CV)	-5.5649086
Kurtosis	64.831787
Mean	-841.51892
Median Absolute Deviation (MAD)	0
Skewness	-7.2020881
Sum	-1.199905 × 10⁸
Variance	21930263
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	119702	83.9%
23.58	16	< 0.1%
23.68	15	< 0.1%
22.79	14	< 0.1%
1.76	14	< 0.1%
23.27	14	< 0.1%
23.86	13	< 0.1%
1.77	13	< 0.1%
23.42	13	< 0.1%
23.48	13	< 0.1%
Other values (14985)	22761	16.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-65869.14	1	< 0.1%
-65863.14	1	< 0.1%
-65692.14	1	< 0.1%
-65578.64	1	< 0.1%
-65482.64	1	< 0.1%
-65476.14	1	< 0.1%
-65142.64	1	< 0.1%
-65020.64	1	< 0.1%
-64684.14	1	< 0.1%
-63829.14	1	< 0.1%

Value	Count	Frequency (%)
17186.2	1	< 0.1%
16850.2	1	< 0.1%
16514.2	1	< 0.1%
16178.2	1	< 0.1%
15842.2	1	< 0.1%
15506.2	1	< 0.1%
15170.2	1	< 0.1%
14834.2	1	< 0.1%
14498.2	1	< 0.1%
14162.2	1	< 0.1%

cancelled_at
Date

MISSING

Distinct	15540
Distinct (%)	67.9%
Missing	119696
Missing (%)	83.9%
Memory size	1.1 MiB

Minimum	2020-07-16 08:36:13+00:00
Maximum	2024-06-08 02:48:31+00:00

Histogram

Histogram with fixed size bins (bins=50)

appointment_type
Text

Distinct	580
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	125
Median length	98
Mean length	46.628188
Min length	4

Characters and Unicode

Total characters	6648620
Distinct characters	85
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	87 ?
Unique (%)	0.1%

Sample

1st row	✅20 Minute Follow Up Consult
2nd row	✅20 Minute Follow Up Consult
3rd row	✅20 Minute Follow Up Consult
4th row	✅20 Minute Follow Up Consult
5th row	✅20 Minute Follow Up Consult

Value	Count	Frequency (%)
	115294	11.9%
subsequent	64724	6.7%
consultation	63100	6.5%
consult	61333	6.3%
2	51540	5.3%
up	49287	5.1%
follow	49211	5.1%
minute	44288	4.6%
physiotherapy	37332	3.8%
30	28483	2.9%
Other values (384)	405940	41.8%

Most occurring characters

Value	Count	Frequency (%)
	833188	12.5%
t	527489	7.9%
o	463384	7.0%
n	434612	6.5%
e	428083	6.4%
i	366282	5.5%
s	362839	5.5%
u	328294	4.9%
l	309964	4.7%
a	278059	4.2%
Other values (75)	2316426	34.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6648620	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	833188	12.5%
t	527489	7.9%
o	463384	7.0%
n	434612	6.5%
e	428083	6.4%
i	366282	5.5%
s	362839	5.5%
u	328294	4.9%
l	309964	4.7%
a	278059	4.2%
Other values (75)	2316426	34.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6648620	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	833188	12.5%
t	527489	7.9%
o	463384	7.0%
n	434612	6.5%
e	428083	6.4%
i	366282	5.5%
s	362839	5.5%
u	328294	4.9%
l	309964	4.7%
a	278059	4.2%
Other values (75)	2316426	34.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6648620	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	833188	12.5%
t	527489	7.9%
o	463384	7.0%
n	434612	6.5%
e	428083	6.4%
i	366282	5.5%
s	362839	5.5%
u	328294	4.9%
l	309964	4.7%
a	278059	4.2%
Other values (75)	2316426	34.8%

billable_item
Text

MISSING

Distinct	427
Distinct (%)	0.3%
Missing	3942
Missing (%)	2.8%
Memory size	1.1 MiB

Length

Max length	125
Median length	102
Mean length	44.604648
Min length	11

Characters and Unicode

Total characters	6184256
Distinct characters	73
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	48 ?
Unique (%)	< 0.1%

Sample

1st row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)
2nd row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)
3rd row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)
4th row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)
5th row	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)

Value	Count	Frequency (%)
	117300	13.7%
subsequent	64758	7.6%
consultation	62269	7.3%
consult	59582	7.0%
up	47246	5.5%
follow	47046	5.5%
osteopathy	43367	5.1%
minute	42426	5.0%
physiotherapy	35882	4.2%
30	29428	3.4%
Other values (286)	307635	35.9%

Most occurring characters

Value	Count	Frequency (%)
	739173	12.0%
t	516423	8.4%
o	453326	7.3%
n	426036	6.9%
e	403064	6.5%
i	359012	5.8%
s	358798	5.8%
u	322138	5.2%
l	308684	5.0%
a	274125	4.4%
Other values (63)	2023477	32.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6184256	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	739173	12.0%
t	516423	8.4%
o	453326	7.3%
n	426036	6.9%
e	403064	6.5%
i	359012	5.8%
s	358798	5.8%
u	322138	5.2%
l	308684	5.0%
a	274125	4.4%
Other values (63)	2023477	32.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6184256	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	739173	12.0%
t	516423	8.4%
o	453326	7.3%
n	426036	6.9%
e	403064	6.5%
i	359012	5.8%
s	358798	5.8%
u	322138	5.2%
l	308684	5.0%
a	274125	4.4%
Other values (63)	2023477	32.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6184256	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	739173	12.0%
t	516423	8.4%
o	453326	7.3%
n	426036	6.9%
e	403064	6.5%
i	359012	5.8%
s	358798	5.8%
u	322138	5.2%
l	308684	5.0%
a	274125	4.4%
Other values (63)	2023477	32.7%

category
Text

MISSING

Distinct	161
Distinct (%)	0.1%
Missing	24476
Missing (%)	17.2%
Memory size	1.1 MiB

Length

Max length	68
Median length	62
Mean length	34.101751
Min length	3

Characters and Unicode

Total characters	4027826
Distinct characters	91
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18 ?
Unique (%)	< 0.1%

Sample

1st row	A \| Pre Pay Online & Save ✅
2nd row	A \| Pre Pay Online & Save ✅
3rd row	A \| Pre Pay Online & Save ✅
4th row	A \| Pre Pay Online & Save ✅
5th row	A \| Pre Pay Online & Save ✅

Value	Count	Frequency (%)
	71336	11.8%
2	42860	7.1%
subsequent	37632	6.2%
consultations	37277	6.2%
for	37115	6.1%
osteopathy	36551	6.0%
existing	35938	5.9%
patients	35938	5.9%
physiotherapy	27515	4.5%
a	26225	4.3%
Other values (205)	216406	35.8%

Most occurring characters

Value	Count	Frequency (%)
	488300	12.1%
t	330438	8.2%
s	285905	7.1%
e	231211	5.7%
n	213718	5.3%
o	192977	4.8%
i	191787	4.8%
a	177585	4.4%
P	130288	3.2%
u	126705	3.1%
Other values (81)	1658912	41.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4027826	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	488300	12.1%
t	330438	8.2%
s	285905	7.1%
e	231211	5.7%
n	213718	5.3%
o	192977	4.8%
i	191787	4.8%
a	177585	4.4%
P	130288	3.2%
u	126705	3.1%
Other values (81)	1658912	41.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4027826	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	488300	12.1%
t	330438	8.2%
s	285905	7.1%
e	231211	5.7%
n	213718	5.3%
o	192977	4.8%
i	191787	4.8%
a	177585	4.4%
P	130288	3.2%
u	126705	3.1%
Other values (81)	1658912	41.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4027826	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	488300	12.1%
t	330438	8.2%
s	285905	7.1%
e	231211	5.7%
n	213718	5.3%
o	192977	4.8%
i	191787	4.8%
a	177585	4.4%
P	130288	3.2%
u	126705	3.1%
Other values (81)	1658912	41.2%

cancelled
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.4 KiB

False	119696
True	22892

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	119696	83.9%
True	22892	16.1%

missed
Boolean

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.4 KiB

False	140606
True	1982

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	140606	98.6%
True	1982	1.4%

appointment_start_time
Date

Distinct	62819
Distinct (%)	44.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2009-08-15 01:30:00+00:00
Maximum	2025-12-31 23:30:00+00:00

Histogram

Histogram with fixed size bins (bins=50)

business_name
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Scarb Physio & Health	32219
All Sorted Physiotherapy	29681
Osteopathy \| Melton	26974
Osteopathy \| Bacchus Marsh	17735
Scarb Remedial Massage	8732
Other values (20)	27247

Length

Max length	30
Median length	26
Mean length	21.578597
Min length	12

Characters and Unicode

Total characters	3076849
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	PhysioCall Gladstone
2nd row	PhysioCall Gladstone
3rd row	PhysioCall Gladstone
4th row	PhysioCall Gladstone
5th row	PhysioCall Gladstone

Common Values

Value	Count	Frequency (%)
Scarb Physio & Health	32219	22.6%
All Sorted Physiotherapy	29681	20.8%
Osteopathy \| Melton	26974	18.9%
Osteopathy \| Bacchus Marsh	17735	12.4%
Scarb Remedial Massage	8732	6.1%
PhysioCall Gladstone	6252	4.4%
Bosch Psychology	5753	4.0%
Newport Physiotherapy	5153	3.6%
Newport Psychology	4207	3.0%
Physiotherapy \| Melton	1407	1.0%
Other values (15)	4475	3.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	80527	17.6%
osteopathy	44709	9.8%
scarb	41897	9.2%
physiotherapy	36410	8.0%
health	32873	7.2%
physio	32219	7.0%
all	29681	6.5%
sorted	29681	6.5%
melton	29331	6.4%
bacchus	18375	4.0%
Other values (25)	81710	17.9%

Most occurring characters

Value	Count	Frequency (%)
	314825	10.2%
h	242304	7.9%
a	235913	7.7%
t	235743	7.7%
o	225274	7.3%
e	218725	7.1%
s	202344	6.6%
y	177814	5.8%
l	161340	5.2%
r	137624	4.5%
Other values (37)	924943	30.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3076849	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	314825	10.2%
h	242304	7.9%
a	235913	7.7%
t	235743	7.7%
o	225274	7.3%
e	218725	7.1%
s	202344	6.6%
y	177814	5.8%
l	161340	5.2%
r	137624	4.5%
Other values (37)	924943	30.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3076849	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	314825	10.2%
h	242304	7.9%
a	235913	7.7%
t	235743	7.7%
o	225274	7.3%
e	218725	7.1%
s	202344	6.6%
y	177814	5.8%
l	161340	5.2%
r	137624	4.5%
Other values (37)	924943	30.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3076849	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	314825	10.2%
h	242304	7.9%
a	235913	7.7%
t	235743	7.7%
o	225274	7.3%
e	218725	7.1%
s	202344	6.6%
y	177814	5.8%
l	161340	5.2%
r	137624	4.5%
Other values (37)	924943	30.1%

customer_type
Categorical

HIGH CORRELATION MISSING

Distinct	35
Distinct (%)	0.1%
Missing	103758
Missing (%)	72.8%
Memory size	1.1 MiB

WorkCover	5945
NDIS	5638
Concession / Pension Card Holder	5346
Medicare Referrals	4281
DVA	3120
Other values (30)	14500

Length

Max length	32
Median length	23
Mean length	12.327221
Min length	3

Characters and Unicode

Total characters	478666
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Staff
2nd row	Staff
3rd row	High Risk
4th row	High Risk
5th row	Staff

Common Values

Value	Count	Frequency (%)
WorkCover	5945	4.2%
NDIS	5638	4.0%
Concession / Pension Card Holder	5346	3.7%
Medicare Referrals	4281	3.0%
DVA	3120	2.2%
NDIS Customer	2474	1.7%
CDM	2449	1.7%
DVA Card Holder	2188	1.5%
Third Party	1716	1.2%
Student	1531	1.1%
Other values (25)	4142	2.9%
(Missing)	103758	72.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ndis	8112	10.6%
card	7538	9.8%
holder	7534	9.8%
workcover	6158	8.0%
	5923	7.7%
medicare	5621	7.3%
concession	5408	7.1%
pension	5346	7.0%
dva	5308	6.9%
referrals	4281	5.6%
Other values (37)	15375	20.1%

Most occurring characters

Value	Count	Frequency (%)
e	50709	10.6%
r	49464	10.3%
o	39555	8.3%
	38209	8.0%
d	24831	5.2%
C	24721	5.2%
n	24050	5.0%
s	24023	5.0%
a	21273	4.4%
i	19786	4.1%
Other values (36)	162045	33.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	478666	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	50709	10.6%
r	49464	10.3%
o	39555	8.3%
	38209	8.0%
d	24831	5.2%
C	24721	5.2%
n	24050	5.0%
s	24023	5.0%
a	21273	4.4%
i	19786	4.1%
Other values (36)	162045	33.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	478666	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	50709	10.6%
r	49464	10.3%
o	39555	8.3%
	38209	8.0%
d	24831	5.2%
C	24721	5.2%
n	24050	5.0%
s	24023	5.0%
a	21273	4.4%
i	19786	4.1%
Other values (36)	162045	33.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	478666	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	50709	10.6%
r	49464	10.3%
o	39555	8.3%
	38209	8.0%
d	24831	5.2%
C	24721	5.2%
n	24050	5.0%
s	24023	5.0%
a	21273	4.4%
i	19786	4.1%
Other values (36)	162045	33.9%

title
Categorical

IMBALANCE MISSING

Distinct	33
Distinct (%)	< 0.1%
Missing	58854
Missing (%)	41.3%
Memory size	1.1 MiB

Mr	31422
Mrs	21231
Ms	17166
Miss	8307
Master	1545
Other values (28)	4063

Length

Max length	15
Median length	2
Mean length	2.5610027
Min length	1

Characters and Unicode

Total characters	214443
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	Mr
2nd row	Mr
3rd row	Miss
4th row	Mr
5th row	Miss

Common Values

Value	Count	Frequency (%)
Mr	31422	22.0%
Mrs	21231	14.9%
Ms	17166	12.0%
Miss	8307	5.8%
Master	1545	1.1%
	1470	1.0%
MISS	928	0.7%
Dr	681	0.5%
MASTER	355	0.2%
Mrs	185	0.1%
Other values (23)	444	0.3%
(Missing)	58854	41.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mr	31635	38.5%
mrs	21417	26.0%
ms	17236	21.0%
miss	9241	11.2%
master	1900	2.3%
dr	681	0.8%
mast	70	0.1%
maste	22	< 0.1%
mx	17	< 0.1%
sr	10	< 0.1%
Other values (9)	32	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
M	81536	38.0%
s	56920	26.5%
r	55286	25.8%
i	8317	3.9%
S	2225	1.0%
	2153	1.0%
a	1651	0.8%
t	1645	0.8%
e	1580	0.7%
I	928	0.4%
Other values (16)	2202	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	214443	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	81536	38.0%
s	56920	26.5%
r	55286	25.8%
i	8317	3.9%
S	2225	1.0%
	2153	1.0%
a	1651	0.8%
t	1645	0.8%
e	1580	0.7%
I	928	0.4%
Other values (16)	2202	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	214443	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	81536	38.0%
s	56920	26.5%
r	55286	25.8%
i	8317	3.9%
S	2225	1.0%
	2153	1.0%
a	1651	0.8%
t	1645	0.8%
e	1580	0.7%
I	928	0.4%
Other values (16)	2202	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	214443	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	81536	38.0%
s	56920	26.5%
r	55286	25.8%
i	8317	3.9%
S	2225	1.0%
	2153	1.0%
a	1651	0.8%
t	1645	0.8%
e	1580	0.7%
I	928	0.4%
Other values (16)	2202	1.0%

state
Text

MISSING

Distinct	74
Distinct (%)	0.1%
Missing	71910
Missing (%)	50.4%
Memory size	1.1 MiB

Length

Max length	17
Median length	3
Mean length	3.1782026
Min length	1

Characters and Unicode

Total characters	224629
Distinct characters	56
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	QLD
2nd row	QLD
3rd row	QLD
4th row	QLD
5th row	QLD

Value	Count	Frequency (%)
qld	61584	86.9%
vic	6462	9.1%
queensland	1293	1.8%
nsw	785	1.1%
west	155	0.2%
gladstone	153	0.2%
victoria	107	0.2%
wa	47	0.1%
newport	22	< 0.1%
sa	19	< 0.1%
Other values (55)	247	0.3%

Most occurring characters

Value	Count	Frequency (%)
Q	62791	28.0%
L	58100	25.9%
D	58081	25.9%
V	6567	2.9%
I	5603	2.5%
C	5448	2.4%
d	5014	2.2%
l	5008	2.2%
e	2993	1.3%
n	2820	1.3%
Other values (46)	12204	5.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	224629	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
Q	62791	28.0%
L	58100	25.9%
D	58081	25.9%
V	6567	2.9%
I	5603	2.5%
C	5448	2.4%
d	5014	2.2%
l	5008	2.2%
e	2993	1.3%
n	2820	1.3%
Other values (46)	12204	5.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	224629	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
Q	62791	28.0%
L	58100	25.9%
D	58081	25.9%
V	6567	2.9%
I	5603	2.5%
C	5448	2.4%
d	5014	2.2%
l	5008	2.2%
e	2993	1.3%
n	2820	1.3%
Other values (46)	12204	5.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	224629	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
Q	62791	28.0%
L	58100	25.9%
D	58081	25.9%
V	6567	2.9%
I	5603	2.5%
C	5448	2.4%
d	5014	2.2%
l	5008	2.2%
e	2993	1.3%
n	2820	1.3%
Other values (46)	12204	5.4%

date_of_birth
Date

MISSING

Distinct	18931
Distinct (%)	13.5%
Missing	2578
Missing (%)	1.8%
Memory size	1.1 MiB

Minimum	1904-01-19 00:00:00
Maximum	2024-04-22 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

sex
Categorical

IMBALANCE MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	49112
Missing (%)	34.4%
Memory size	1.1 MiB

Female	56870
Male	34880
9	1405
female	152
male	143
Other values (3)	26

Length

Max length	6
Median length	6
Mean length	5.1750931
Min length	1

Characters and Unicode

Total characters	483747
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Male
2nd row	Male
3rd row	Male
4th row	Male
5th row	Male

Common Values

Value	Count	Frequency (%)
Female	56870	39.9%
Male	34880	24.5%
9	1405	1.0%
female	152	0.1%
male	143	0.1%
Other	13	< 0.1%
AMAB	12	< 0.1%
other	1	< 0.1%
(Missing)	49112	34.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	57022	61.0%
male	35023	37.5%
9	1405	1.5%
other	14	< 0.1%
amab	12	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	149081	30.8%
a	92045	19.0%
l	92045	19.0%
m	57165	11.8%
F	56870	11.8%
M	34892	7.2%
9	1405	0.3%
f	152	< 0.1%
A	24	< 0.1%
t	14	< 0.1%
Other values (5)	54	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	483747	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	149081	30.8%
a	92045	19.0%
l	92045	19.0%
m	57165	11.8%
F	56870	11.8%
M	34892	7.2%
9	1405	0.3%
f	152	< 0.1%
A	24	< 0.1%
t	14	< 0.1%
Other values (5)	54	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	483747	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	149081	30.8%
a	92045	19.0%
l	92045	19.0%
m	57165	11.8%
F	56870	11.8%
M	34892	7.2%
9	1405	0.3%
f	152	< 0.1%
A	24	< 0.1%
t	14	< 0.1%
Other values (5)	54	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	483747	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	149081	30.8%
a	92045	19.0%
l	92045	19.0%
m	57165	11.8%
F	56870	11.8%
M	34892	7.2%
9	1405	0.3%
f	152	< 0.1%
A	24	< 0.1%
t	14	< 0.1%
Other values (5)	54	< 0.1%

post_code
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	51112
Missing (%)	35.8%
Memory size	1.1 MiB

city
Text

MISSING

Distinct	901
Distinct (%)	1.0%
Missing	49994
Missing (%)	35.1%
Memory size	1.1 MiB

Length

Max length	43
Median length	25
Mean length	9.4585826
Min length	2

Characters and Unicode

Total characters	875808
Distinct characters	69
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	170 ?
Unique (%)	0.2%

Sample

1st row	South Gladstone
2nd row	Clinton
3rd row	Gladstone
4th row	South Gladstone
5th row	Toolooa

Value	Count	Frequency (%)
scarborough	17321	15.4%
gladstone	16019	14.3%
newport	8419	7.5%
redcliffe	7433	6.6%
margate	3798	3.4%
clontarf	2991	2.7%
bay	2570	2.3%
deception	2523	2.2%
kippa	2198	2.0%
ring	2198	2.0%
Other values (627)	46856	41.7%

Most occurring characters

Value	Count	Frequency (%)
o	64155	7.3%
r	56642	6.5%
a	48844	5.6%
e	48273	5.5%
S	37112	4.2%
N	36826	4.2%
c	28424	3.2%
t	27851	3.2%
l	27652	3.2%
A	27031	3.1%
Other values (59)	472998	54.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	875808	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	64155	7.3%
r	56642	6.5%
a	48844	5.6%
e	48273	5.5%
S	37112	4.2%
N	36826	4.2%
c	28424	3.2%
t	27851	3.2%
l	27652	3.2%
A	27031	3.1%
Other values (59)	472998	54.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	875808	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	64155	7.3%
r	56642	6.5%
a	48844	5.6%
e	48273	5.5%
S	37112	4.2%
N	36826	4.2%
c	28424	3.2%
t	27851	3.2%
l	27652	3.2%
A	27031	3.1%
Other values (59)	472998	54.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	875808	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	64155	7.3%
r	56642	6.5%
a	48844	5.6%
e	48273	5.5%
S	37112	4.2%
N	36826	4.2%
c	28424	3.2%
t	27851	3.2%
l	27652	3.2%
A	27031	3.1%
Other values (59)	472998	54.0%

occupation
Text

MISSING

Distinct	3868
Distinct (%)	5.2%
Missing	68082
Missing (%)	47.7%
Memory size	1.1 MiB

Length

Max length	57
Median length	45
Mean length	11.767549
Min length	1

Characters and Unicode

Total characters	876753
Distinct characters	80
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1322 ?
Unique (%)	1.8%

Sample

1st row	Physio
2nd row	Remedial massage therapist
3rd row	QAL Operator
4th row	Physio
5th row	Student

Value	Count	Frequency (%)
retired	14268	12.2%
student	5763	4.9%
manager	4207	3.6%
teacher	3681	3.1%
worker	2161	1.8%
nurse	2001	1.7%
officer	1833	1.6%
assistant	1816	1.6%
driver	1562	1.3%
support	1432	1.2%
Other values (2083)	78373	66.9%

Most occurring characters

Value	Count	Frequency (%)
e	117204	13.4%
r	85633	9.8%
t	74321	8.5%
i	66308	7.6%
a	55452	6.3%
n	50426	5.8%
	44914	5.1%
o	38126	4.3%
d	36019	4.1%
s	35166	4.0%
Other values (70)	273184	31.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	876753	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	117204	13.4%
r	85633	9.8%
t	74321	8.5%
i	66308	7.6%
a	55452	6.3%
n	50426	5.8%
	44914	5.1%
o	38126	4.3%
d	36019	4.1%
s	35166	4.0%
Other values (70)	273184	31.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	876753	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	117204	13.4%
r	85633	9.8%
t	74321	8.5%
i	66308	7.6%
a	55452	6.3%
n	50426	5.8%
	44914	5.1%
o	38126	4.3%
d	36019	4.1%
s	35166	4.0%
Other values (70)	273184	31.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	876753	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	117204	13.4%
r	85633	9.8%
t	74321	8.5%
i	66308	7.6%
a	55452	6.3%
n	50426	5.8%
	44914	5.1%
o	38126	4.3%
d	36019	4.1%
s	35166	4.0%
Other values (70)	273184	31.2%

referred
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.4 KiB

False	97591
True	44997

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	97591	68.4%
True	44997	31.6%

Auto

Heatmap
Table

		appointment_status	business_name	cancelled	case_linked	case_type	customer_type	day_of_month	day_of_week	missed	month_of_year	month_period	notice	patient_status	patient_type	referred	sex	time_of_day	title	total_cxl_appointments_before_appointment	total_good_appointments_before_appointment	total_open_invoices_before_appointemnt	week_of_year
	1.000	0.105	1.000	0.183	0.147	0.191	0.787	0.002	0.128	0.021	0.107	0.011	-0.127	0.071	0.149	0.400	0.059	0.126	0.222	-0.255	-0.197	-0.095	-0.009
appointment_status	0.105	1.000	0.325	0.016	0.286	0.022	0.445	0.000	0.061	0.016	0.040	0.000	0.096	0.196	0.138	0.121	0.085	0.083	0.101	0.279	0.368	0.261	-0.017
business_name	1.000	0.325	1.000	0.223	0.673	0.306	0.325	-0.002	0.113	0.042	0.066	0.020	0.259	0.118	0.160	0.671	0.107	0.180	0.121	-0.048	0.064	0.080	-0.036
cancelled	0.183	0.016	0.223	1.000	0.104	0.061	0.114	-0.003	0.024	0.052	0.018	0.001	0.328	0.019	0.182	0.000	0.052	0.054	0.079	0.278	0.041	0.026	0.004
case_linked	0.147	0.286	0.673	0.104	1.000	1.000	0.352	-0.001	0.093	0.032	0.096	0.000	0.180	0.201	0.083	0.443	0.185	0.145	0.245	0.123	0.331	0.128	-0.078
case_type	0.191	0.022	0.306	0.061	1.000	1.000	0.342	-0.005	0.068	0.031	0.033	0.004	0.064	0.037	0.040	0.128	0.031	0.069	0.050	0.028	0.058	0.005	-0.017
customer_type	0.787	0.445	0.325	0.114	0.352	0.342	1.000	0.002	0.117	0.063	0.055	0.012	-0.028	0.162	0.132	0.436	0.182	0.190	0.189	0.110	0.191	0.280	-0.023
day_of_month	0.002	0.000	-0.002	-0.003	-0.001	-0.005	0.002	1.000	0.035	0.004	0.073	0.964	0.003	0.003	0.007	0.006	0.001	0.005	0.000	-0.005	-0.005	0.008	0.050
day_of_week	0.128	0.061	0.113	0.024	0.093	0.068	0.117	0.035	1.000	0.006	0.027	0.031	0.012	0.015	0.063	0.074	0.023	0.137	0.034	0.020	0.038	0.006	-0.017
missed	0.021	0.016	0.042	0.052	0.032	0.031	0.063	0.004	0.006	1.000	0.023	0.000	-0.017	0.026	0.044	0.020	0.038	0.007	0.035	0.014	0.020	0.029	-0.002
month_of_year	0.107	0.040	0.066	0.018	0.096	0.033	0.055	0.073	0.027	0.023	1.000	0.078	-0.027	0.056	0.045	0.051	0.013	0.010	0.021	0.012	-0.017	-0.009	0.308
month_period	0.011	0.000	0.020	0.001	0.000	0.004	0.012	0.964	0.031	0.000	0.078	1.000	-0.002	0.004	0.006	0.001	0.000	0.000	0.000	-0.001	-0.002	-0.001	0.035
notice	-0.127	0.096	0.259	0.328	0.180	0.064	-0.028	0.003	0.012	-0.017	-0.027	-0.002	1.000	0.023	0.079	0.133	0.021	0.042	0.072	-0.139	0.023	0.048	-0.033
patient_status	0.071	0.196	0.118	0.019	0.201	0.037	0.162	0.003	0.015	0.026	0.056	0.004	0.023	1.000	0.045	0.128	0.031	0.028	0.044	0.080	0.096	-0.012	-0.065
patient_type	0.149	0.138	0.160	0.182	0.083	0.040	0.132	0.007	0.063	0.044	0.045	0.006	0.079	0.045	1.000	0.084	0.027	0.122	0.048	-0.055	-0.035	-0.027	0.023
referred	0.400	0.121	0.671	0.000	0.443	0.128	0.436	0.006	0.074	0.020	0.051	0.001	0.133	0.128	0.084	1.000	0.123	0.154	0.215	0.071	0.106	0.031	-0.021
sex	0.059	0.085	0.107	0.052	0.185	0.031	0.182	0.001	0.023	0.038	0.013	0.000	0.021	0.031	0.027	0.123	1.000	0.049	0.442	-0.069	0.003	0.067	-0.011
time_of_day	0.126	0.083	0.180	0.054	0.145	0.069	0.190	0.005	0.137	0.007	0.010	0.000	0.042	0.028	0.122	0.154	0.049	1.000	0.089	0.042	0.021	0.029	0.002
title	0.222	0.101	0.121	0.079	0.245	0.050	0.189	0.000	0.034	0.035	0.021	0.000	0.072	0.044	0.048	0.215	0.442	0.089	1.000	0.083	0.071	0.020	-0.012
total_cxl_appointments_before_appointment	-0.255	0.279	-0.048	0.278	0.123	0.028	0.110	-0.005	0.020	0.014	0.012	-0.001	-0.139	0.080	-0.055	0.071	-0.069	0.042	0.083	1.000	0.570	0.192	0.020
total_good_appointments_before_appointment	-0.197	0.368	0.064	0.041	0.331	0.058	0.191	-0.005	0.038	0.020	-0.017	-0.002	0.023	0.096	-0.035	0.106	0.003	0.021	0.071	0.570	1.000	0.252	-0.015
total_open_invoices_before_appointemnt	-0.095	0.261	0.080	0.026	0.128	0.005	0.280	0.008	0.006	0.029	-0.009	-0.001	0.048	-0.012	-0.027	0.031	0.067	0.029	0.020	0.192	0.252	1.000	-0.017
week_of_year	-0.009	-0.017	-0.036	0.004	-0.078	-0.017	-0.023	0.050	-0.017	-0.002	0.308	0.035	-0.033	-0.065	0.023	-0.021	-0.011	0.002	-0.012	0.020	-0.015	-0.017	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

		case_linked	case_type	total_good_appointments_before_appointment	patient_status	patient_type	time_of_day	month_period	day_of_week	month_of_year	day_of_month	week_of_year	appointment_status	next_appointment_time	notice	cancelled_at	appointment_type	billable_item	category	cancelled	missed	appointment_start_time	business_name	customer_type	title	state	date_of_birth	sex	post_code	city	occupation	referred
0	11	No	NaN	0	Not Yet Actioned	New To Clinic	Early Morning	Mid month	Friday	July	17.0	29.0	Not Rebooked	NaN	12.73	2020-07-16 08:36:13+00	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	Yes	No	2020-07-16 21:20:00+00	PhysioCall Gladstone	Staff	Mr	QLD	1984-02-03	Male	4680.0	South Gladstone	Physio	Yes
1	11	No	NaN	0	Not Yet Actioned	Recurring	Late Afternoon	Mid month	Thursday	August	13.0	33.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-08-13 06:00:00+00	PhysioCall Gladstone	NaN	NaN	NaN	1997-01-30	NaN	NaN	NaN	NaN	No
2	11	No	NaN	1	Not Yet Actioned	Recurring	Late Morning	Mid month	Thursday	August	20.0	34.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-08-20 01:20:00+00	PhysioCall Gladstone	NaN	NaN	NaN	1997-01-30	NaN	NaN	NaN	NaN	No
3	11	No	NaN	2	Not Yet Actioned	Recurring	Late Morning	Mid month	Friday	September	18.0	38.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-09-17 23:50:00+00	PhysioCall Gladstone	NaN	NaN	NaN	1997-01-30	NaN	NaN	NaN	NaN	No
4	11	No	NaN	0	Not Yet Actioned	New To Clinic	Early Morning	End month	Monday	September	21.0	39.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-09-20 22:20:00+00	PhysioCall Gladstone	NaN	NaN	NaN	1980-02-03	NaN	NaN	NaN	NaN	No
5	11	No	NaN	0	Not Yet Actioned	Recurring	Late Afternoon	Mid month	Tuesday	October	20.0	43.0	Not Rebooked	NaN	0.00	NaN	✅40 Minute Follow Up Consult	NaN	1. PhysioCall - Pre Pay Online & Save ✅	No	No	2020-10-20 05:10:00+00	PhysioCall Gladstone	NaN	Mr	QLD	1977-06-30	NaN	4680.0	Clinton	Remedial massage therapist	Yes
6	11	No	NaN	0	Not Yet Actioned	new injury/issue	Evening	Mid month	Sunday	October	18.0	42.0	Not Rebooked	NaN	0.00	NaN	✅60 Minute - Initial Consult Massage	NaN	1. Gladstone Massage - Prepay Online & Save ✅	No	No	2020-10-18 10:30:00+00	Gladstone Massage	NaN	NaN	NaN	1988-07-09	NaN	NaN	NaN	NaN	No
7	11	Yes	Unlimited	0	Not Yet Actioned	Recurring	Late Morning	Mid month	Monday	October	19.0	43.0	Not Rebooked	NaN	0.00	NaN	2. 20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult	A \| Physiotherapy Treatment ❤️‍🩹 (in clinic)	No	No	2020-10-19 00:40:00+00	PhysioCall Gladstone	NaN	NaN	NaN	1979-09-18	NaN	NaN	NaN	NaN	No
8	11	No	NaN	0	Not Yet Actioned	Recurring	Late Morning	Mid month	Monday	October	19.0	43.0	Not Rebooked	NaN	0.00	NaN	✅20 Minute Follow Up Consult	PhysioCall - 20 Minute Follow Up Consult (Pre-paid)	A \| Pre Pay Online & Save ✅	No	No	2020-10-19 01:00:00+00	PhysioCall Gladstone	NaN	NaN	NaN	1994-01-16	NaN	NaN	NaN	NaN	No
9	11	Yes	Unlimited	0	Not Yet Actioned	Recurring	Late Morning	Mid month	Monday	October	19.0	43.0	Not Rebooked	NaN	0.00	NaN	40 Minute Follow Up Consult	NaN	2. PhysioCall - Pay In Clinic	No	No	2020-10-19 01:20:00+00	PhysioCall Gladstone	NaN	Miss	QLD	1994-03-05	NaN	4680.0	Gladstone	QAL Operator	Yes

		case_linked	case_type	total_good_appointments_before_appointment	total_cxl_appointments_before_appointment	patient_status	patient_type	time_of_day	month_period	day_of_week	month_of_year	day_of_month	week_of_year	appointment_status	next_appointment_time	cancelled_at	appointment_type	billable_item	category	cancelled	missed	appointment_start_time	business_name	customer_type	title	state	date_of_birth	sex	post_code	city	occupation	referred
142578	16	Yes	Max Sessions	11	3	Therapist Follow Up	Recurring	Late Afternoon	Mid month	Saturday	July	20.0	29.0	Not Rebooked	NaN	NaN	✨ Osteopathy CDM - Subsequent Consultation	Osteopathy CDM - Subsequent Consultation	CDM (Medicare / GP Referrals)	No	No	2024-07-20 02:00:00+00	Osteopathy \| Melton	NaN	NaN	NaN	1994-04-07	NaN	NaN	NaN	Administration	No
142579	16	No	NaN	2	1	Patient Stopped Treatment	Recurring	Late Afternoon	End month	Saturday	June	22.0	25.0	Not Rebooked	NaN	NaN	✨ Osteopathy - Subsequent Consultation	Osteopathy - Subsequent Consultation	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-22 02:00:00+00	Osteopathy \| Melton	NaN	NaN	NaN	1979-10-26	NaN	NaN	NaN	NaN	No
142580	16	Yes	Unlimited	16	1	Has An Upcoming Booking	Recurring	Late Morning	Mid month	Wednesday	June	19.0	25.0	Rebooked	2024-06-22 10:30:00	NaN	2. Physiotherapy WorkSafe - Subsequent Consultation	Physiotherapy WorkSafe - Subsequent Consultation	WorkSafe	No	No	2024-06-19 00:30:00+00	Physiotherapy \| Melton	NaN	Mr	NaN	1989-10-06	Male	NaN	NaN	NaN	No
142581	16	Yes	Unlimited	17	1	Has An Upcoming Booking	Recurring	Late Morning	End month	Saturday	June	22.0	25.0	Rebooked	2024-06-26 10:30:00	NaN	2. Physiotherapy WorkSafe - Subsequent Consultation	Physiotherapy WorkSafe - Subsequent Consultation	WorkSafe	No	No	2024-06-22 00:30:00+00	Physiotherapy \| Melton	NaN	Mr	NaN	1989-10-06	Male	NaN	NaN	NaN	No
142582	16	Yes	Unlimited	18	1	Has An Upcoming Booking	Recurring	Late Morning	End month	Wednesday	June	26.0	26.0	Rebooked	2024-06-29 11:00:00	NaN	2. Physiotherapy WorkSafe - Subsequent Consultation	Physiotherapy WorkSafe - Subsequent Consultation	WorkSafe	No	No	2024-06-26 00:30:00+00	Physiotherapy \| Melton	NaN	Mr	NaN	1989-10-06	Male	NaN	NaN	NaN	No
142583	16	No	NaN	28	4	Admin Follow Up	Recurring	Late Afternoon	Mid month	Tuesday	June	18.0	25.0	Not Rebooked	NaN	NaN	⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath	Osteopathy - Subsequent Consultation With Senior Osteopath	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-18 02:00:00+00	Osteopathy \| Bacchus Marsh	NaN	NaN	NaN	1989-02-17	Female	NaN	NaN	Courier	No
142584	16	Yes	Unlimited	19	1	Has An Upcoming Booking	Recurring	Late Morning	End month	Saturday	June	29.0	26.0	Not Rebooked	NaN	NaN	2. Physiotherapy WorkSafe - Subsequent Consultation	Physiotherapy WorkSafe - Subsequent Consultation	WorkSafe	No	No	2024-06-29 01:00:00+00	Physiotherapy \| Melton	NaN	Mr	NaN	1989-10-06	Male	NaN	NaN	NaN	No
142585	16	Yes	Unlimited	10	0	Not Yet Actioned	Recurring	Late Afternoon	Mid month	Monday	June	17.0	25.0	Not Rebooked	NaN	NaN	✨ Osteopathy - Subsequent Consultation	Osteopathy - Subsequent Consultation	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-17 05:15:00+00	Osteopathy \| Bacchus Marsh	NaN	Mrs	VIC	1963-12-18	Female	3340	Bacchus Marsh	Woolworths team member	Yes
142586	16	No	NaN	2	0	Not Yet Actioned	Recurring	Evening	Mid month	Wednesday	June	12.0	24.0	Not Rebooked	NaN	NaN	⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath	Osteopathy - Subsequent Consultation With Senior Osteopath	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-12 09:30:00+00	Osteopathy \| Bacchus Marsh	NaN	NaN	NaN	1968-05-28	NaN	NaN	NaN	NaN	No
142587	16	Yes	Unlimited	17	4	Therapist Follow Up	Recurring	Late Afternoon	Mid month	Wednesday	June	19.0	25.0	Not Rebooked	NaN	NaN	⭐️ Osteopathy - Subsequent Consultation With Senior Osteopath	Osteopathy - Subsequent Consultation With Senior Osteopath	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2024-06-19 05:00:00+00	Osteopathy \| Melton	NDIS	NaN	VIc	1955-11-08	Female	3338	Melton South	Self Employed	No

Most frequently occurring

		case_linked	case_type	total_good_appointments_before_appointment	total_cxl_appointments_before_appointment	patient_status	patient_type	time_of_day	month_period	day_of_week	month_of_year	day_of_month	week_of_year	appointment_status	next_appointment_time	notice	cancelled_at	appointment_type	billable_item	category	cancelled	missed	appointment_start_time	business_name	customer_type	title	state	date_of_birth	sex	city	occupation	referred	# duplicates
0	13	No	NaN	0	2	Not Yet Actioned	New To Clinic	Late Afternoon	End month	Monday	May	21.0	21.0	Not Rebooked	NaN	-25905.13	2021-05-04 13:07:52+00	Initial Consultation week day	Initial Consultation week day	NaN	Yes	No	2018-05-21 04:00:00+00	All Sorted Physiotherapy	NaN	NaN	NaN	NaN	Male	CALLIOPE	NaN	No	2
1	13	No	NaN	0	5	Not Yet Actioned	New To Clinic	Late Afternoon	Mid month	Thursday	June	14.0	24.0	Not Rebooked	NaN	-25331.13	2021-05-04 13:07:47+00	Initial Consultation week day	Initial Consultation week day	NaN	Yes	No	2018-06-14 02:00:00+00	All Sorted Physiotherapy	NaN	NaN	NaN	1984-09-28	Female	GLADSTONE	NaN	No	2
2	13	No	NaN	0	13	Not Yet Actioned	New To Clinic	Late Morning	End month	Thursday	May	24.0	21.0	Not Rebooked	NaN	-25835.63	2021-05-04 13:07:51+00	Initial Consultation week day	Initial Consultation week day	NaN	Yes	No	2018-05-24 01:30:00+00	All Sorted Physiotherapy	NaN	Ms	NaN	1991-09-19	Female	GLADSTONE	NaN	No	2
3	13	No	NaN	13	6	Not Yet Actioned	Recurring	Late Afternoon	Mid month	Thursday	June	14.0	24.0	Not Rebooked	NaN	-25327.63	2021-05-04 13:07:46+00	Subsequent Consultation week day	Subsequent Consultation week day	NaN	Yes	No	2018-06-14 05:30:00+00	All Sorted Physiotherapy	NaN	Mr	NaN	1956-10-10	Male	GLADSTONE	NaN	No	2
4	13	No	NaN	17	4	Not Yet Actioned	Recurring	Late Morning	Early month	Thursday	July	5.0	27.0	Not Rebooked	NaN	-24830.13	2021-05-04 13:07:42+00	Subsequent Consultation week day	Subsequent Consultation week day	NaN	Yes	No	2018-07-04 23:00:00+00	All Sorted Physiotherapy	NaN	Ms	NaN	1997-01-16	Female	GLADSTONE	NaN	No	2
5	16	No	NaN	0	0	Not Yet Actioned	New To Clinic	Late Morning	End month	Friday	April	21.0	16.0	Not Rebooked	NaN	0.00	NaN	⚡️Osteopathy - Subsequent Consultation with Supervising Clinician	Osteopathy - Subsequent Consultation with Supervising Clinician	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2023-04-20 23:00:00+00	⬅️ Front Desk Migration	NaN	NaN	NaN	1958-06-24	NaN	NaN	Barista	No	2
6	16	No	NaN	0	0	Not Yet Actioned	New To Clinic	Late Morning	End month	Friday	July	21.0	29.0	Not Rebooked	NaN	0.00	NaN	⚡️Osteopathy - Subsequent Consultation with Supervising Clinician	Osteopathy - Subsequent Consultation with Supervising Clinician	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2023-07-20 23:30:00+00	⬅️ Front Desk Migration	NaN	NaN	NaN	1971-03-12	NaN	NaN	NaN	No	2
7	16	No	NaN	0	0	Not Yet Actioned	New To Clinic	Late Morning	End month	Friday	March	24.0	12.0	Not Rebooked	NaN	0.00	NaN	⚡️Osteopathy - Subsequent Consultation with Supervising Clinician	Osteopathy - Subsequent Consultation with Supervising Clinician	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2023-03-23 23:00:00+00	⬅️ Front Desk Migration	NaN	NaN	NaN	1994-04-16	NaN	NaN	Retail Manager	No	2
8	16	No	NaN	0	0	Not Yet Actioned	New To Clinic	Late Morning	End month	Wednesday	February	22.0	8.0	Not Rebooked	NaN	0.00	NaN	⚡️Osteopathy - Subsequent Consultation with Supervising Clinician	Osteopathy - Subsequent Consultation with Supervising Clinician	2. Subsequent Osteopathy Consultations for Existing Patients	No	No	2023-02-21 23:00:00+00	⬅️ Front Desk Migration	NaN	NaN	NaN	1944-12-16	NaN	NaN	Retired	No	2
9	16	No	NaN	0	0	Not Yet Actioned	New To Clinic	Late Morning	Mid month	Friday	July	14.0	28.0	Not Rebooked	NaN	0.00	NaN	⚡️Osteopathy CDM - Subsequent Consultation with Supervising Clinician	Osteopathy CDM - Subsequent Consultation with Supervising Clinician	CDM (Medicare / GP Referrals)	No	No	2023-07-13 23:30:00+00	⬅️ Front Desk Migration	NaN	NaN	NaN	1960-01-17	NaN	NaN	Cleaner	No	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)